from sqlalchemy import Column
from sqlalchemy.sql.sqltypes import Integer, String, Text, TIMESTAMP
from sqlalchemy.ext.declarative import declarative_base

Base = declarative_base()

class Inverst(Base):
    __tablename__ = "TYC_IC_INVERST"
    ORGTYPE = Column(String(255))
    BUSINESS_SCOPE = Column(String(4000))
    PERCENT = Column(String(255))
    REGSTATUS = Column(String(255))
    ESTIBLISHTIME = Column(Integer)
    LEGALPERSONNAME = Column(String(255))
    TYPE = Column(Integer)
    AMOUNT = Column(Integer)
    ID = Column(Integer)
    CATEGORY = Column(String(255))
    REGCAPITAL = Column(String(255))
    NAME = Column(String(255))
    BASE = Column(String(255))
    CREDITCODE = Column(String(255))
    PERSONTYPE = Column(Integer)
    ALIAS = Column(String(255))
    AMOUNTSUFFIX = Column(String(255))

    ENTNAME = Column(String(100))
    PRIPID = Column(String(36))
    REGNO = Column(String(50))
    UNISCID = Column(String(18))
    CREATE_TIME = Column(TIMESTAMP)
    UPDATE_TIME = Column(TIMESTAMP)